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 869: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;

865: l_old_location_id1 VARCHAR2(100);
866: l_old_location_id2 VARCHAR2(100);
867: l_trx_date OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE;
868: l_asset_id OKC_K_LINES_V.ID%TYPE;
869: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;
870: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
871:
872: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
873: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

Line 870: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;

866: l_old_location_id2 VARCHAR2(100);
867: l_trx_date OKL_TRX_ASSETS.DATE_TRANS_OCCURRED%TYPE;
868: l_asset_id OKC_K_LINES_V.ID%TYPE;
869: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;
870: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
871:
872: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
873: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
874: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

Line 880: FROM okx_party_site_uses_v

876: 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
877: SELECT
878: PARTY_SITE_ID,
879: LOCATION_ID
880: FROM okx_party_site_uses_v
881: WHERE ID1 = p_id1 AND ID2 = p_id2;
882:
883: -- Bug#4274575 - smadhava - 28-Sep-2005 - Added - End
884: begin

Line 1217: FROM okx_party_site_uses_v

1213: 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
1214: SELECT
1215: PARTY_SITE_ID,
1216: LOCATION_ID
1217: FROM okx_party_site_uses_v
1218: WHERE ID1 = p_id1 AND ID2 = p_id2;
1219:
1220: CURSOR okl_inst_csr (p_kle_id IN OKL_TXL_ITM_INSTS.KLE_ID%TYPE) IS
1221: SELECT