APPS.OKL_SSC_WF dependencies on OKX_PARTY_SITE_USES_V

Line 696: OKX_PARTY_SITE_USES_V PSU1,

692: PSU1.DESCRIPTION OLD_LOCATION,
693: PSU2.DESCRIPTION NEW_LOCATION,
694: TRX.DATE_TRANS_OCCURRED EFFECTIVE_DATE
695: from OKL_TXL_ITM_INSTS INX,
696: OKX_PARTY_SITE_USES_V PSU1,
697: OKX_PARTY_SITE_USES_V PSU2,
698: OKL_TXL_ASSETS_B ASX,
699: OKL_TRX_ASSETS TRX
700: where

Line 697: OKX_PARTY_SITE_USES_V PSU2,

693: PSU2.DESCRIPTION NEW_LOCATION,
694: TRX.DATE_TRANS_OCCURRED EFFECTIVE_DATE
695: from OKL_TXL_ITM_INSTS INX,
696: OKX_PARTY_SITE_USES_V PSU1,
697: OKX_PARTY_SITE_USES_V PSU2,
698: OKL_TXL_ASSETS_B ASX,
699: OKL_TRX_ASSETS TRX
700: where
701: INX.TAS_ID = p_tas_id

Line 733: l_old_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;

729: l_new_location_id2 VARCHAR2(100);
730: l_trx_date DATE;
731: l_asset_id VARCHAR2(100);
732: l_asset_number OKC_K_LINES_V.NAME%TYPE;
733: l_old_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;
734: l_new_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;
735:
736: CURSOR c_get_location(cp_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE,
737: cp_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS

Line 734: l_new_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;

730: l_trx_date DATE;
731: l_asset_id VARCHAR2(100);
732: l_asset_number OKC_K_LINES_V.NAME%TYPE;
733: l_old_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;
734: l_new_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;
735:
736: CURSOR c_get_location(cp_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE,
737: cp_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
738: SELECT PSU.DESCRIPTION

Line 739: FROM OKX_PARTY_SITE_USES_V PSU

735:
736: CURSOR c_get_location(cp_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE,
737: cp_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
738: SELECT PSU.DESCRIPTION
739: FROM OKX_PARTY_SITE_USES_V PSU
740: WHERE PSU.ID1 = cp_id1
741: AND PSU.ID2 = cp_id2;
742:
743: CURSOR c_get_asset_dtls(cp_kle_id IN OKC_K_LINES_V.ID%TYPE) IS

Line 918: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;

914: l_old_location_id1 VARCHAR2(100);
915: l_old_location_id2 VARCHAR2(100);
916: l_trx_date OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE;
917: l_asset_id OKC_K_LINES_V.ID%TYPE;
918: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;
919: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
920:
921: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
922: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

Line 919: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;

915: l_old_location_id2 VARCHAR2(100);
916: l_trx_date OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE;
917: l_asset_id OKC_K_LINES_V.ID%TYPE;
918: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;
919: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
920:
921: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
922: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
923: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

Line 929: FROM okx_party_site_uses_v

925: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
926: SELECT
927: PARTY_SITE_ID,
928: LOCATION_ID
929: FROM okx_party_site_uses_v
930: WHERE ID1 = p_id1 AND ID2 = p_id2;
931:
932: -- Bug#4274575 - smadhava - 28-Sep-2005 - Added - End
933:

Line 1303: FROM okx_party_site_uses_v

1299: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
1300: SELECT
1301: PARTY_SITE_ID,
1302: LOCATION_ID
1303: FROM okx_party_site_uses_v
1304: WHERE ID1 = p_id1 AND ID2 = p_id2;
1305:
1306: CURSOR okl_inst_csr (p_kle_id IN OKL_TXL_ITM_INSTS.KLE_ID%TYPE) IS
1307: SELECT